import pandas as pd
from backend.webInterface.busi_pre import precidt_id

data = pd.read_excel('../source/elm.xlsx')
print('reading data---', data.head())
top_1000 = data.head(1000)
# top_100['id_pre'] = top_100.img_card.apply(lambda x: precidt_id(x.split(',')[0], 'ID'))

# data['id_pre'] = data.head(100).img_card.apply(lambda x: precidt_id(x.split(',')[0], 'ID'))
# data['license_pre'] = data.img_card.apply(lambda x: precidt_id(x, ''))
top_1000['license_pre'] = top_1000.img_license.apply(lambda x: precidt_id(x, ''))
print('over!')
